Usage Note 36300: Unable to modify relational data in a pivot table in the SAS® Add-In for Microsoft Office
 |  |  |  |
After you open a relational data set into a pivot table using the SAS Add-In for Microsoft Office, you cannot open the Modify Data Source dialog box in order modify your initial column selections or to apply filters.
As a workaround for the inability to add more columns, you can initially select all of the columns that you think you might need. You do not have to include all of your columns in the pivot table, but you can ensure that they are available if you need them.
As a workaround for filters, you can use the Page Filter on the Pivot tables in Excel 2003 or the Report Filter in Excel 2007.
Your only other option is to create a new pivot table and make new column and filter selections.
The SAS Add-In for Microsoft Office 4.2 enables you open the Modify Data Source dialog box to make changes.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Microsoft Windows 95/98 | 2.1 | |||
| Microsoft Windows 2000 Advanced Server | 2.1 | |||||
| Microsoft Windows 2000 Datacenter Server | 2.1 | |||||
| Microsoft Windows 2000 Server | 2.1 | |||||
| Microsoft Windows 2000 Professional | 2.1 | |||||
| Microsoft Windows NT Workstation | 2.1 | |||||
| Microsoft Windows Server 2003 Datacenter Edition | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2008 | 2.1 | |||||
| Microsoft Windows XP Professional | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Windows Millennium Edition (Me) | 2.1 | |||||
| Windows Vista | 2.1 | 4.2 | 9.2 TS2M0 | |||
| Type: | Usage Note |
| Priority: | |
| Topic: | Third Party ==> Products ==> Microsoft Office |
| Date Modified: | 2009-08-06 15:57:33 |
| Date Created: | 2009-06-19 16:45:22 |